SUPPORT / SAMPLES & SAS NOTES
Problem Note 54042: Performance is slow when you open a SAS® Financial Management data-entry form
 |  |  |  |  |
You might experience slow performance when you open a SAS Financial Management data-entry form if there are more than 32-thousand cell protection rules. In this case, an error similar to the following is displayed in the SAS® Add-In for Microsoft Excel log:
[06/10/2014 13:20:42,388] VSTA_Main: SERVER: getCellMetadata() took 24.241s
(************************), service ticket took 0s
[06/10/2014 13:20:42,395] --------------- EXCEPTION REPORT---------------
[06/10/2014 13:20:42,401] error retrieving protection map
[06/10/2014 13:20:42,407] System.Web.Services.Protocols.SoapException:
java.lang.RuntimeException: No value specified for parameter 5,683.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, BooleanasyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(StringmethodName, Object[] parameters)
at Com.Sas.Ses.OfficeIntegration.Server.ODCS.ODCSWebService.getCellMetadata(Int32queryOptions,
DataProtectionQuery query, SliceDescriptorsliceDescriptor)
at Com.Sas.Ses.OfficeIntegration.Model.ODCSWebServiceOverride.getCellMetadata(Int32queryOptions,
DataProtectionQuery query, SliceDescriptorsliceDescriptor)
at Com.Sas.Ses.OfficeIntegration.View.Table.getProtectionMap(SliceDescriptorsliceDescriptor,
DataProtectionInfo dpi, CellMetadataCachecellMetadataCache, Boolean cacheRatherThanSetBitsInMap)
at Com.Sas.Ses.OfficeIntegration.View.Table.getProtectionMap(BooleanhiddenInfoOnly, SliceDescriptor
sliceDescriptorOverride)
[06/10/2014 13:20:42,413] ----------- END OF EXCEPTION REPORT------------If you encounter this problem, contact SAS Technical Support.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 |
| Microsoft Windows 8 Enterprise 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 R2 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Datacenter | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Std | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Std | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Home Premium x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Professional 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Professional x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Ultimate x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| 64-bit Enabled AIX | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| 64-bit Enabled Solaris | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Linux for x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||